--doris添加字段
CREATE TABLE jms_dm.dm_employee_operate_effective_dt (
                                                         agent_code varchar(50) NULL COMMENT "代理区code",
                                                         center_code varchar(50) NULL COMMENT "中心code",
                                                         date_time date NULL COMMENT " 日期",
                                                         agent_name varchar(120) NULL COMMENT "代理区name",
                                                         center_name varchar(120) NULL COMMENT "中心名称",
                                                         institution_code varchar(50) NULL COMMENT "标准组织code",
                                                         institution_name varchar(120) NULL COMMENT "标准组织name",
                                                         institutiona_code varchar(50) NULL COMMENT "组织code",
                                                         institutiona_name varchar(120) NULL COMMENT "组织name",
                                                         schedule_code varchar(50) NULL COMMENT "班次code",
                                                         schedule_name varchar(120) NULL COMMENT "班次name",
                                                         operate_num int(11) NULL COMMENT "操作量",
                                                         formal_number decimal64(16, 2) NULL COMMENT "自有员工操作数",
                                                         informal_number decimal64(16, 2) NULL COMMENT "外包临时工人数",
                                                         effectiveness decimal64(16, 2) NULL COMMENT "效能",
                                                         up_operate_num int(11) NULL COMMENT "上一日操作量",
                                                         up_formal_number decimal64(16, 2) NULL COMMENT "上一日自有员工操作数",
                                                         up_informal_number decimal64(16, 2) NULL COMMENT "上一日外包临时工人数",
                                                         up_effectiveness decimal64(16, 2) NULL COMMENT "上一日效能",
                                                         org_type varchar(65533) NULL COMMENT "维度：institutiona 班组，center中心 "
) ENGINE=OLAP
DUPLICATE KEY(agent_code,center_code)
COMMENT "智能设备_员工——操作效能"
PARTITION BY RANGE(date_time)
(START ("2023-07-01") END ("2023-08-15") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(center_code) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-60",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);


alter table jms_dm.dm_employee_operate_effective_dt add column
    (
      formal_hours   decimal(16,2) comment'正式工在岗时长'
     ,noformal_hours decimal(16,2) comment'临时工在岗时长'
     ,up_formal_hours   decimal(16,2) comment'上一天正式工在岗时长'
     ,up_noformal_hours decimal(16,2) comment'上一天临时工在岗时长'
)